﻿CREATE TABLE [dbo].[User] (
    [UserID]    INT           IDENTITY (1, 1) NOT NULL,
    [Username]  VARCHAR (50)  NULL,
    [Password]  VARCHAR (50)  NULL,
    [Email]     VARCHAR (255) NULL,
    [CountryID] INT           NULL,
    [Active]    BIT           NULL,
    CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED ([UserID] ASC),
    CONSTRAINT [FK_User_Country] FOREIGN KEY ([CountryID]) REFERENCES [dbo].[Country] ([CountryID])
);

